package com.jsy.goods.dao;

import com.jsy.goods.pojo.Brand;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/****
 * @Author:www.jsy.com
 * @Description:Brand的Dao
 * @Date www.jsy.com
 *****/
public interface BrandMapper extends Mapper<Brand> {
    @Select("SELECT b.* FROM tb_brand AS b,tb_category_brand AS cb WHERE b.id=cb.brand_id AND cb.category_id=#{categoryId}")
    List<Brand> findByCategoryId(Integer categoryId);
}
